clear all
set more off
set maxvar 32000
set matsize 11000
*************************************************************************************************
*set scheme aspen, perm
grstyle init
grstyle set plain, horizontal grid

use "$folder/data/data_ready.dta", clear
cd "$folder/output/tables"
local x=18

xtset state year, yearly delta(2)

*******************
* List of Topics
*******************

preserve
keep share18_provision*  state year
collapse(mean)  share18_provision*
gen i=1
reshape long share18_provision, i(i) j(share18_provision_)
keep share18_provision
sort share18_provision

outsheet share18_provision using Table_1_topics.csv, replace

restore

